﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCompras" targetNamespace="http://tempuri.org/dsCompras.xsd" xmlns:mstns="http://tempuri.org/dsCompras.xsd" xmlns="http://tempuri.org/dsCompras.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="COM_ENCABEZADOORDENCOMPRATableAdapter" GeneratorDataComponentClassName="COM_ENCABEZADOORDENCOMPRATableAdapter" Name="COM_ENCABEZADOORDENCOMPRA" UserDataComponentName="COM_ENCABEZADOORDENCOMPRATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."COM_ENCABEZADOORDENCOMPRA" WHERE (((:IsNull_BODEGAPARA = 1 AND "BODEGAPARA" IS NULL) OR ("BODEGAPARA" = :Original_BODEGAPARA)) AND ((:IsNull_IDCENTROSUMI = 1 AND "IDCENTROSUMI" IS NULL) OR ("IDCENTROSUMI" = :Original_IDCENTROSUMI)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_FECHAPAGO = 1 AND "FECHAPAGO" IS NULL) OR ("FECHAPAGO" = :Original_FECHAPAGO)) AND ((:IsNull_FECHARECEPCION = 1 AND "FECHARECEPCION" IS NULL) OR ("FECHARECEPCION" = :Original_FECHARECEPCION)) AND ((:IsNull_IDMINPADRE = 1 AND "IDMINPADRE" IS NULL) OR ("IDMINPADRE" = :Original_IDMINPADRE)) AND ((:IsNull_IDPROVEEDOR = 1 AND "IDPROVEEDOR" IS NULL) OR ("IDPROVEEDOR" = :Original_IDPROVEEDOR)) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_NUMEROPEDIDO = 1 AND "NUMEROPEDIDO" IS NULL) OR ("NUMEROPEDIDO" = :Original_NUMEROPEDIDO)) AND ((:IsNull_SUCURSALGLOBALCOM = 1 AND "SUCURSALGLOBALCOM" IS NULL) OR ("SUCURSALGLOBALCOM" = :Original_SUCURSALGLOBALCOM)) AND ("TIPODOC" = :Original_TIPODOC) AND ((:IsNull_ESTADOORDEN = 1 AND "ESTADOORDEN" IS NULL) OR ("ESTADOORDEN" = :Original_ESTADOORDEN)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BODEGAPARA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BODEGAPARA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCENTROSUMI" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAPAGO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHARECEPCION" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHARECEPCION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMINPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMINPADRE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROPEDIDO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROPEDIDO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSALGLOBALCOM" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SUCURSALGLOBALCOM" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADOORDEN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADOORDEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."COM_ENCABEZADOORDENCOMPRA" ("BODEGAPARA", "IDCENTROSUMI", "FECHA", "FECHAPAGO", "FECHARECEPCION", "IDMINPADRE", "IDPROVEEDOR", "NUMERO", "NUMEROPEDIDO", "SUCURSALGLOBALCOM", "TIPODOC", "ESTADOORDEN", "IDCCOSTO", "IDFORMAPAGO") VALUES (:BODEGAPARA, :IDCENTROSUMI, :FECHA, :FECHAPAGO, :FECHARECEPCION, :IDMINPADRE, :IDPROVEEDOR, :NUMERO, :NUMEROPEDIDO, :SUCURSALGLOBALCOM, :TIPODOC, :ESTADOORDEN, :IDCCOSTO, :IDFORMAPAGO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BODEGAPARA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAPAGO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHARECEPCION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMINPADRE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROPEDIDO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SUCURSALGLOBALCOM" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADOORDEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BODEGAPARA, IDCENTROSUMI, FECHA, FECHAPAGO, FECHARECEPCION, IDMINPADRE, IDPROVEEDOR, NUMERO, NUMEROPEDIDO, SUCURSALGLOBALCOM, TIPODOC, ESTADOORDEN, IDCCOSTO, IDFORMAPAGO FROM SAMUEL.COM_ENCABEZADOORDENCOMPRA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."COM_ENCABEZADOORDENCOMPRA" SET "BODEGAPARA" = :BODEGAPARA, "IDCENTROSUMI" = :IDCENTROSUMI, "FECHA" = :FECHA, "FECHAPAGO" = :FECHAPAGO, "FECHARECEPCION" = :FECHARECEPCION, "IDMINPADRE" = :IDMINPADRE, "IDPROVEEDOR" = :IDPROVEEDOR, "NUMERO" = :NUMERO, "NUMEROPEDIDO" = :NUMEROPEDIDO, "SUCURSALGLOBALCOM" = :SUCURSALGLOBALCOM, "TIPODOC" = :TIPODOC, "ESTADOORDEN" = :ESTADOORDEN, "IDCCOSTO" = :IDCCOSTO, "IDFORMAPAGO" = :IDFORMAPAGO WHERE (((:IsNull_BODEGAPARA = 1 AND "BODEGAPARA" IS NULL) OR ("BODEGAPARA" = :Original_BODEGAPARA)) AND ((:IsNull_IDCENTROSUMI = 1 AND "IDCENTROSUMI" IS NULL) OR ("IDCENTROSUMI" = :Original_IDCENTROSUMI)) AND ((:IsNull_FECHA = 1 AND "FECHA" IS NULL) OR ("FECHA" = :Original_FECHA)) AND ((:IsNull_FECHAPAGO = 1 AND "FECHAPAGO" IS NULL) OR ("FECHAPAGO" = :Original_FECHAPAGO)) AND ((:IsNull_FECHARECEPCION = 1 AND "FECHARECEPCION" IS NULL) OR ("FECHARECEPCION" = :Original_FECHARECEPCION)) AND ((:IsNull_IDMINPADRE = 1 AND "IDMINPADRE" IS NULL) OR ("IDMINPADRE" = :Original_IDMINPADRE)) AND ((:IsNull_IDPROVEEDOR = 1 AND "IDPROVEEDOR" IS NULL) OR ("IDPROVEEDOR" = :Original_IDPROVEEDOR)) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_NUMEROPEDIDO = 1 AND "NUMEROPEDIDO" IS NULL) OR ("NUMEROPEDIDO" = :Original_NUMEROPEDIDO)) AND ((:IsNull_SUCURSALGLOBALCOM = 1 AND "SUCURSALGLOBALCOM" IS NULL) OR ("SUCURSALGLOBALCOM" = :Original_SUCURSALGLOBALCOM)) AND ("TIPODOC" = :Original_TIPODOC) AND ((:IsNull_ESTADOORDEN = 1 AND "ESTADOORDEN" IS NULL) OR ("ESTADOORDEN" = :Original_ESTADOORDEN)) AND ((:IsNull_IDCCOSTO = 1 AND "IDCCOSTO" IS NULL) OR ("IDCCOSTO" = :Original_IDCCOSTO)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BODEGAPARA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHAPAGO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="FECHARECEPCION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMINPADRE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NUMEROPEDIDO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SUCURSALGLOBALCOM" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADOORDEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BODEGAPARA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BODEGAPARA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="BODEGAPARA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCENTROSUMI" Precision="0" ProviderType="Int32" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHAPAGO" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FECHARECEPCION" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_FECHARECEPCION" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="FECHARECEPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMINPADRE" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMINPADRE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDMINPADRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NUMEROPEDIDO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NUMEROPEDIDO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="NUMEROPEDIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SUCURSALGLOBALCOM" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SUCURSALGLOBALCOM" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="SUCURSALGLOBALCOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADOORDEN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADOORDEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCCOSTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BODEGAPARA" DataSetColumn="BODEGAPARA" />
              <Mapping SourceColumn="IDCENTROSUMI" DataSetColumn="IDCENTROSUMI" />
              <Mapping SourceColumn="FECHA" DataSetColumn="FECHA" />
              <Mapping SourceColumn="FECHAPAGO" DataSetColumn="FECHAPAGO" />
              <Mapping SourceColumn="FECHARECEPCION" DataSetColumn="FECHARECEPCION" />
              <Mapping SourceColumn="IDMINPADRE" DataSetColumn="IDMINPADRE" />
              <Mapping SourceColumn="IDPROVEEDOR" DataSetColumn="IDPROVEEDOR" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="NUMEROPEDIDO" DataSetColumn="NUMEROPEDIDO" />
              <Mapping SourceColumn="SUCURSALGLOBALCOM" DataSetColumn="SUCURSALGLOBALCOM" />
              <Mapping SourceColumn="TIPODOC" DataSetColumn="TIPODOC" />
              <Mapping SourceColumn="ESTADOORDEN" DataSetColumn="ESTADOORDEN" />
              <Mapping SourceColumn="IDCCOSTO" DataSetColumn="IDCCOSTO" />
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipoDocnumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoDocnumero" GeneratorSourceName="FillByTipoDocnumero" GetMethodModifier="Public" GetMethodName="GetDataByTipoDocnumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoDocnumero" UserSourceName="FillByTipoDocnumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     BODEGAPARA, FECHA, FECHAPAGO, FECHARECEPCION, IDMINPADRE, IDPROVEEDOR, NUMERO, NUMEROPEDIDO, SUCURSALGLOBALCOM, 
                      TIPODOC, ESTADOORDEN, IDCCOSTO, IDFORMAPAGO, IDCENTROSUMI
FROM         COM_ENCABEZADOORDENCOMPRA
WHERE     (TIPODOC = :PTIPODOC) AND (NUMERO = :PNUEMRO) </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PTIPODOC" ColumnName="TIPODOC" DataSourceName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PTIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUEMRO" ColumnName="NUMERO" DataSourceName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUEMRO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="updateEstadoOrden" Modifier="Public" Name="updateEstadoOrden" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="updateEstadoOrden">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    COM_ENCABEZADOORDENCOMPRA
SET              ESTADOORDEN = :PESTADO
WHERE     (NUMERO = :PNUMERO) AND (TIPODOC = :PTIPODOC)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PESTADO" ColumnName="ESTADOORDEN" DataSourceName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PESTADO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADOORDEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PTIPODOC" ColumnName="TIPODOC" DataSourceName="SAMUEL.COM_ENCABEZADOORDENCOMPRA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PTIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="COM_DETALLEORDENCOMPRATableAdapter" GeneratorDataComponentClassName="COM_DETALLEORDENCOMPRATableAdapter" Name="COM_DETALLEORDENCOMPRA" UserDataComponentName="COM_DETALLEORDENCOMPRATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.COM_DETALLEORDENCOMPRA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "COM_DETALLEORDENCOMPRA" WHERE (("TIPODOC" = :Original_TIPODOC) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_CANTIDAD = 1 AND "CANTIDAD" IS NULL) OR ("CANTIDAD" = :Original_CANTIDAD)) AND ((:IsNull_DESCUENTO = 1 AND "DESCUENTO" IS NULL) OR ("DESCUENTO" = :Original_DESCUENTO)) AND ((:IsNull_IDIVA = 1 AND "IDIVA" IS NULL) OR ("IDIVA" = :Original_IDIVA)) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_IDPRODUCTOPROVEEDOR = 1 AND "IDPRODUCTOPROVEEDOR" IS NULL) OR ("IDPRODUCTOPROVEEDOR" = :Original_IDPRODUCTOPROVEEDOR)) AND ((:IsNull_PRECIOBASE = 1 AND "PRECIOBASE" IS NULL) OR ("PRECIOBASE" = :Original_PRECIOBASE)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)) AND ((:IsNull_UNIDADPROVEEDOR = 1 AND "UNIDADPROVEEDOR" IS NULL) OR ("UNIDADPROVEEDOR" = :Original_UNIDADPROVEEDOR)) AND ("LINEA" = :Original_LINEA) AND ((:IsNull_PRECIOIVA = 1 AND "PRECIOIVA" IS NULL) OR ("PRECIOIVA" = :Original_PRECIOIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDADPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDADPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_LINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="LINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "COM_DETALLEORDENCOMPRA" ("TIPODOC", "NUMERO", "CANTIDAD", "DESCUENTO", "IDIVA", "IDPRODUCTO", "IDPRODUCTOPROVEEDOR", "PRECIOBASE", "UNIDAD", "UNIDADPROVEEDOR", "LINEA", "PRECIOIVA") VALUES (:TIPODOC, :NUMERO, :CANTIDAD, :DESCUENTO, :IDIVA, :IDPRODUCTO, :IDPRODUCTOPROVEEDOR, :PRECIOBASE, :UNIDAD, :UNIDADPROVEEDOR, :LINEA, :PRECIOIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDADPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="LINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TIPODOC, NUMERO, CANTIDAD, DESCUENTO, IDIVA, IDPRODUCTO, IDPRODUCTOPROVEEDOR, PRECIOBASE, UNIDAD, UNIDADPROVEEDOR, LINEA, PRECIOIVA FROM COM_DETALLEORDENCOMPRA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "COM_DETALLEORDENCOMPRA" SET "TIPODOC" = :TIPODOC, "NUMERO" = :NUMERO, "CANTIDAD" = :CANTIDAD, "DESCUENTO" = :DESCUENTO, "IDIVA" = :IDIVA, "IDPRODUCTO" = :IDPRODUCTO, "IDPRODUCTOPROVEEDOR" = :IDPRODUCTOPROVEEDOR, "PRECIOBASE" = :PRECIOBASE, "UNIDAD" = :UNIDAD, "UNIDADPROVEEDOR" = :UNIDADPROVEEDOR, "LINEA" = :LINEA, "PRECIOIVA" = :PRECIOIVA WHERE (("TIPODOC" = :Original_TIPODOC) AND ("NUMERO" = :Original_NUMERO) AND ((:IsNull_CANTIDAD = 1 AND "CANTIDAD" IS NULL) OR ("CANTIDAD" = :Original_CANTIDAD)) AND ((:IsNull_DESCUENTO = 1 AND "DESCUENTO" IS NULL) OR ("DESCUENTO" = :Original_DESCUENTO)) AND ((:IsNull_IDIVA = 1 AND "IDIVA" IS NULL) OR ("IDIVA" = :Original_IDIVA)) AND ("IDPRODUCTO" = :Original_IDPRODUCTO) AND ((:IsNull_IDPRODUCTOPROVEEDOR = 1 AND "IDPRODUCTOPROVEEDOR" IS NULL) OR ("IDPRODUCTOPROVEEDOR" = :Original_IDPRODUCTOPROVEEDOR)) AND ((:IsNull_PRECIOBASE = 1 AND "PRECIOBASE" IS NULL) OR ("PRECIOBASE" = :Original_PRECIOBASE)) AND ((:IsNull_UNIDAD = 1 AND "UNIDAD" IS NULL) OR ("UNIDAD" = :Original_UNIDAD)) AND ((:IsNull_UNIDADPROVEEDOR = 1 AND "UNIDADPROVEEDOR" IS NULL) OR ("UNIDADPROVEEDOR" = :Original_UNIDADPROVEEDOR)) AND ("LINEA" = :Original_LINEA) AND ((:IsNull_PRECIOIVA = 1 AND "PRECIOIVA" IS NULL) OR ("PRECIOIVA" = :Original_PRECIOIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UNIDADPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="LINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PRECIOIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_NUMERO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDAD" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCUENTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESCUENTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDIVA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTOPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTOPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOBASE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOBASE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOBASE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDAD" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDAD" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDAD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDADPROVEEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UNIDADPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="UNIDADPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_LINEA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="LINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PRECIOIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PRECIOIVA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PRECIOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TIPODOC" DataSetColumn="TIPODOC" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="CANTIDAD" DataSetColumn="CANTIDAD" />
              <Mapping SourceColumn="DESCUENTO" DataSetColumn="DESCUENTO" />
              <Mapping SourceColumn="IDIVA" DataSetColumn="IDIVA" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="IDPRODUCTOPROVEEDOR" DataSetColumn="IDPRODUCTOPROVEEDOR" />
              <Mapping SourceColumn="PRECIOBASE" DataSetColumn="PRECIOBASE" />
              <Mapping SourceColumn="UNIDAD" DataSetColumn="UNIDAD" />
              <Mapping SourceColumn="UNIDADPROVEEDOR" DataSetColumn="UNIDADPROVEEDOR" />
              <Mapping SourceColumn="LINEA" DataSetColumn="LINEA" />
              <Mapping SourceColumn="PRECIOIVA" DataSetColumn="PRECIOIVA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.COM_DETALLEORDENCOMPRA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipoDocNumero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipoDocNumero" GeneratorSourceName="FillByTipoDocNumero" GetMethodModifier="Public" GetMethodName="GetDataByTipoDocNumero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipoDocNumero" UserSourceName="FillByTipoDocNumero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CANTIDAD, DESCUENTO, IDIVA, IDPRODUCTO, IDPRODUCTOPROVEEDOR, LINEA, NUMERO, PRECIOBASE, PRECIOIVA, TIPODOC, UNIDAD, 
                         UNIDADPROVEEDOR
FROM            COM_DETALLEORDENCOMPRA
WHERE        (TIPODOC = :PTIPODOC) AND (NUMERO = :PNUMERO)
ORDER BY LINEA, NUMERO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PTIPODOC" ColumnName="TIPODOC" DataSourceName="SAMUEL.COM_DETALLEORDENCOMPRA" DataTypeServer="NVARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PTIPODOC" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PNUMERO" ColumnName="NUMERO" DataSourceName="SAMUEL.COM_DETALLEORDENCOMPRA" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PNUMERO" Precision="20" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="COM_CENTROSUMITableAdapter" GeneratorDataComponentClassName="COM_CENTROSUMITableAdapter" Name="COM_CENTROSUMI" UserDataComponentName="COM_CENTROSUMITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.COM_CENTROSUMI" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."COM_CENTROSUMI" WHERE (("IDCENTROSUMI" = :Original_IDCENTROSUMI) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."COM_CENTROSUMI" ("IDCENTROSUMI", "DESCRIPCION") VALUES (:IDCENTROSUMI, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCENTROSUMI, DESCRIPCION FROM SAMUEL.COM_CENTROSUMI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."COM_CENTROSUMI" SET "IDCENTROSUMI" = :IDCENTROSUMI, "DESCRIPCION" = :DESCRIPCION WHERE (("IDCENTROSUMI" = :Original_IDCENTROSUMI) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCENTROSUMI" Precision="0" ProviderType="Varchar2" Scale="0" Size="10" SourceColumn="IDCENTROSUMI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCENTROSUMI" DataSetColumn="IDCENTROSUMI" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCompras" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsCompras" msprop:Generator_DataSetName="dsCompras" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="COM_ENCABEZADOORDENCOMPRA" msprop:Generator_UserTableName="COM_ENCABEZADOORDENCOMPRA" msprop:Generator_RowDeletedName="COM_ENCABEZADOORDENCOMPRARowDeleted" msprop:Generator_RowChangedName="COM_ENCABEZADOORDENCOMPRARowChanged" msprop:Generator_RowClassName="COM_ENCABEZADOORDENCOMPRARow" msprop:Generator_RowChangingName="COM_ENCABEZADOORDENCOMPRARowChanging" msprop:Generator_RowEvArgName="COM_ENCABEZADOORDENCOMPRARowChangeEvent" msprop:Generator_RowEvHandlerName="COM_ENCABEZADOORDENCOMPRARowChangeEventHandler" msprop:Generator_TableClassName="COM_ENCABEZADOORDENCOMPRADataTable" msprop:Generator_TableVarName="tableCOM_ENCABEZADOORDENCOMPRA" msprop:Generator_RowDeletingName="COM_ENCABEZADOORDENCOMPRARowDeleting" msprop:Generator_TablePropName="COM_ENCABEZADOORDENCOMPRA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BODEGAPARA" msprop:Generator_UserColumnName="BODEGAPARA" msprop:Generator_ColumnVarNameInTable="columnBODEGAPARA" msprop:Generator_ColumnPropNameInRow="BODEGAPARA" msprop:Generator_ColumnPropNameInTable="BODEGAPARAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCENTROSUMI" msprop:Generator_UserColumnName="IDCENTROSUMI" msprop:Generator_ColumnVarNameInTable="columnIDCENTROSUMI" msprop:Generator_ColumnPropNameInRow="IDCENTROSUMI" msprop:Generator_ColumnPropNameInTable="IDCENTROSUMIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FECHA" msprop:Generator_UserColumnName="FECHA" msprop:Generator_ColumnVarNameInTable="columnFECHA" msprop:Generator_ColumnPropNameInRow="FECHA" msprop:Generator_ColumnPropNameInTable="FECHAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FECHAPAGO" msprop:Generator_UserColumnName="FECHAPAGO" msprop:Generator_ColumnVarNameInTable="columnFECHAPAGO" msprop:Generator_ColumnPropNameInRow="FECHAPAGO" msprop:Generator_ColumnPropNameInTable="FECHAPAGOColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FECHARECEPCION" msprop:Generator_UserColumnName="FECHARECEPCION" msprop:Generator_ColumnVarNameInTable="columnFECHARECEPCION" msprop:Generator_ColumnPropNameInRow="FECHARECEPCION" msprop:Generator_ColumnPropNameInTable="FECHARECEPCIONColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDMINPADRE" msprop:Generator_UserColumnName="IDMINPADRE" msprop:Generator_ColumnVarNameInTable="columnIDMINPADRE" msprop:Generator_ColumnPropNameInRow="IDMINPADRE" msprop:Generator_ColumnPropNameInTable="IDMINPADREColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPROVEEDOR" msprop:Generator_UserColumnName="IDPROVEEDOR" msprop:Generator_ColumnVarNameInTable="columnIDPROVEEDOR" msprop:Generator_ColumnPropNameInRow="IDPROVEEDOR" msprop:Generator_ColumnPropNameInTable="IDPROVEEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="NUMEROPEDIDO" msprop:Generator_UserColumnName="NUMEROPEDIDO" msprop:Generator_ColumnVarNameInTable="columnNUMEROPEDIDO" msprop:Generator_ColumnPropNameInRow="NUMEROPEDIDO" msprop:Generator_ColumnPropNameInTable="NUMEROPEDIDOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUCURSALGLOBALCOM" msprop:Generator_UserColumnName="SUCURSALGLOBALCOM" msprop:Generator_ColumnVarNameInTable="columnSUCURSALGLOBALCOM" msprop:Generator_ColumnPropNameInRow="SUCURSALGLOBALCOM" msprop:Generator_ColumnPropNameInTable="SUCURSALGLOBALCOMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPODOC" msprop:Generator_UserColumnName="TIPODOC" msprop:Generator_ColumnVarNameInTable="columnTIPODOC" msprop:Generator_ColumnPropNameInRow="TIPODOC" msprop:Generator_ColumnPropNameInTable="TIPODOCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESTADOORDEN" msprop:Generator_UserColumnName="ESTADOORDEN" msprop:Generator_ColumnVarNameInTable="columnESTADOORDEN" msprop:Generator_ColumnPropNameInRow="ESTADOORDEN" msprop:Generator_ColumnPropNameInTable="ESTADOORDENColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDCCOSTO" msprop:Generator_UserColumnName="IDCCOSTO" msprop:Generator_ColumnVarNameInTable="columnIDCCOSTO" msprop:Generator_ColumnPropNameInRow="IDCCOSTO" msprop:Generator_ColumnPropNameInTable="IDCCOSTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="COM_DETALLEORDENCOMPRA" msprop:Generator_UserTableName="COM_DETALLEORDENCOMPRA" msprop:Generator_RowDeletedName="COM_DETALLEORDENCOMPRARowDeleted" msprop:Generator_RowChangedName="COM_DETALLEORDENCOMPRARowChanged" msprop:Generator_RowClassName="COM_DETALLEORDENCOMPRARow" msprop:Generator_RowChangingName="COM_DETALLEORDENCOMPRARowChanging" msprop:Generator_RowEvArgName="COM_DETALLEORDENCOMPRARowChangeEvent" msprop:Generator_RowEvHandlerName="COM_DETALLEORDENCOMPRARowChangeEventHandler" msprop:Generator_TableClassName="COM_DETALLEORDENCOMPRADataTable" msprop:Generator_TableVarName="tableCOM_DETALLEORDENCOMPRA" msprop:Generator_RowDeletingName="COM_DETALLEORDENCOMPRARowDeleting" msprop:Generator_TablePropName="COM_DETALLEORDENCOMPRA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TIPODOC" msprop:Generator_UserColumnName="TIPODOC" msprop:Generator_ColumnVarNameInTable="columnTIPODOC" msprop:Generator_ColumnPropNameInRow="TIPODOC" msprop:Generator_ColumnPropNameInTable="TIPODOCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_UserColumnName="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" type="xs:decimal" />
              <xs:element name="CANTIDAD" msprop:Generator_UserColumnName="CANTIDAD" msprop:Generator_ColumnVarNameInTable="columnCANTIDAD" msprop:Generator_ColumnPropNameInRow="CANTIDAD" msprop:Generator_ColumnPropNameInTable="CANTIDADColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="DESCUENTO" msprop:Generator_UserColumnName="DESCUENTO" msprop:Generator_ColumnVarNameInTable="columnDESCUENTO" msprop:Generator_ColumnPropNameInRow="DESCUENTO" msprop:Generator_ColumnPropNameInTable="DESCUENTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDIVA" msprop:Generator_UserColumnName="IDIVA" msprop:Generator_ColumnVarNameInTable="columnIDIVA" msprop:Generator_ColumnPropNameInRow="IDIVA" msprop:Generator_ColumnPropNameInTable="IDIVAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTOPROVEEDOR" msprop:Generator_UserColumnName="IDPRODUCTOPROVEEDOR" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTOPROVEEDOR" msprop:Generator_ColumnPropNameInRow="IDPRODUCTOPROVEEDOR" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOPROVEEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRECIOBASE" msprop:Generator_UserColumnName="PRECIOBASE" msprop:Generator_ColumnVarNameInTable="columnPRECIOBASE" msprop:Generator_ColumnPropNameInRow="PRECIOBASE" msprop:Generator_ColumnPropNameInTable="PRECIOBASEColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="UNIDAD" msprop:Generator_UserColumnName="UNIDAD" msprop:Generator_ColumnVarNameInTable="columnUNIDAD" msprop:Generator_ColumnPropNameInRow="UNIDAD" msprop:Generator_ColumnPropNameInTable="UNIDADColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UNIDADPROVEEDOR" msprop:Generator_UserColumnName="UNIDADPROVEEDOR" msprop:Generator_ColumnVarNameInTable="columnUNIDADPROVEEDOR" msprop:Generator_ColumnPropNameInRow="UNIDADPROVEEDOR" msprop:Generator_ColumnPropNameInTable="UNIDADPROVEEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LINEA" msprop:Generator_UserColumnName="LINEA" msprop:Generator_ColumnVarNameInTable="columnLINEA" msprop:Generator_ColumnPropNameInRow="LINEA" msprop:Generator_ColumnPropNameInTable="LINEAColumn" type="xs:decimal" />
              <xs:element name="PRECIOIVA" msprop:Generator_UserColumnName="PRECIOIVA" msprop:Generator_ColumnVarNameInTable="columnPRECIOIVA" msprop:Generator_ColumnPropNameInRow="PRECIOIVA" msprop:Generator_ColumnPropNameInTable="PRECIOIVAColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORLINEA" msdata:ReadOnly="true" msdata:Expression="(CANTIDAD*PRECIOBASE)+(CANTIDAD*PRECIOIVA)" msprop:Generator_UserColumnName="VALORLINEA" msprop:Generator_ColumnVarNameInTable="columnVALORLINEA" msprop:Generator_ColumnPropNameInRow="VALORLINEA" msprop:Generator_ColumnPropNameInTable="VALORLINEAColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="COM_CENTROSUMI" msprop:Generator_UserTableName="COM_CENTROSUMI" msprop:Generator_RowDeletedName="COM_CENTROSUMIRowDeleted" msprop:Generator_RowChangedName="COM_CENTROSUMIRowChanged" msprop:Generator_RowClassName="COM_CENTROSUMIRow" msprop:Generator_RowChangingName="COM_CENTROSUMIRowChanging" msprop:Generator_RowEvArgName="COM_CENTROSUMIRowChangeEvent" msprop:Generator_RowEvHandlerName="COM_CENTROSUMIRowChangeEventHandler" msprop:Generator_TableClassName="COM_CENTROSUMIDataTable" msprop:Generator_TableVarName="tableCOM_CENTROSUMI" msprop:Generator_RowDeletingName="COM_CENTROSUMIRowDeleting" msprop:Generator_TablePropName="COM_CENTROSUMI">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCENTROSUMI" msprop:Generator_UserColumnName="IDCENTROSUMI" msprop:Generator_ColumnVarNameInTable="columnIDCENTROSUMI" msprop:Generator_ColumnPropNameInRow="IDCENTROSUMI" msprop:Generator_ColumnPropNameInTable="IDCENTROSUMIColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:COM_ENCABEZADOORDENCOMPRA" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:TIPODOC" />
    </xs:unique>
    <xs:unique name="COM_DETALLEORDENCOMPRA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:COM_DETALLEORDENCOMPRA" />
      <xs:field xpath="mstns:TIPODOC" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:IDPRODUCTO" />
      <xs:field xpath="mstns:LINEA" />
    </xs:unique>
    <xs:unique name="COM_CENTROSUMI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:COM_CENTROSUMI" />
      <xs:field xpath="mstns:IDCENTROSUMI" />
    </xs:unique>
    <xs:keyref name="FK_COM_ENCABEZADOORDENCOMPRA_COM_DETALLEORDENCOMPRA" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_COM_ENCABEZADOORDENCOMPRA_COM_DETALLEORDENCOMPRA" msprop:rel_Generator_RelationVarName="relationFK_COM_ENCABEZADOORDENCOMPRA_COM_DETALLEORDENCOMPRA" msprop:rel_Generator_UserChildTable="COM_DETALLEORDENCOMPRA" msprop:rel_Generator_UserParentTable="COM_ENCABEZADOORDENCOMPRA" msprop:rel_Generator_ParentPropName="COM_ENCABEZADOORDENCOMPRARowParent" msprop:rel_Generator_ChildPropName="GetCOM_DETALLEORDENCOMPRARows">
      <xs:selector xpath=".//mstns:COM_DETALLEORDENCOMPRA" />
      <xs:field xpath="mstns:NUMERO" />
      <xs:field xpath="mstns:TIPODOC" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ENCORDENCOMPRA_CENTROSUMI" msdata:parent="COM_CENTROSUMI" msdata:child="COM_ENCABEZADOORDENCOMPRA" msdata:parentkey="IDCENTROSUMI" msdata:childkey="IDCENTROSUMI" msprop:Generator_UserRelationName="FK_ENCORDENCOMPRA_CENTROSUMI" msprop:Generator_RelationVarName="relationFK_ENCORDENCOMPRA_CENTROSUMI" msprop:Generator_UserChildTable="COM_ENCABEZADOORDENCOMPRA" msprop:Generator_UserParentTable="COM_CENTROSUMI" msprop:Generator_ParentPropName="COM_CENTROSUMIRow" msprop:Generator_ChildPropName="GetCOM_ENCABEZADOORDENCOMPRARows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>